=!dataprep.eda.create_report.reportReport)}reportX DataPrep Report

Overview

Dataset Statistics

Number of Variables 19
Number of Rows 1488
Missing Cells 870
Missing Cells (%) 3.1%
Duplicate Rows 0
Duplicate Rows (%) 0.0%
Total Size in Memory 232.5 KB
Average Row Size in Memory 160.0 B
Variable Types
  • Numerical: 18
  • Categorical: 1

Dataset Insights

sin48_settlement_period and cos48_settlement_period have similar distributions Similar Distribution
-1000 pressure and 1000 pressure have similar distributions Similar Distribution
ema_half_hour has 290 (19.49%) missing values Missing
MACD has 290 (19.49%) missing values Missing
atr has 290 (19.49%) missing values Missing
MACD is skewed Skewed
atr is skewed Skewed
weighted_top_sell is skewed Skewed
-1 pressure is skewed Skewed
-1000 pressure is skewed Skewed
1 pressure is skewed Skewed
MACD_2 is skewed Skewed
lolp_2hour has constant value "0.0" Constant
lolp_2hour has constant length 3 Constant Length
ets_half_hour_price has 39 (2.62%) negatives Negatives
sin48_settlement_period has 744 (50.0%) negatives Negatives
cos48_settlement_period has 744 (50.0%) negatives Negatives
ema_half_hour has 37 (2.49%) negatives Negatives
MACD has 507 (34.07%) negatives Negatives
weighted_top_buy has 103 (6.92%) negatives Negatives
weighted_top_sell has 28 (1.88%) negatives Negatives
MACD_2 has 795 (53.43%) negatives Negatives
MACD has 172 (11.56%) zeros Zeros
atr has 225 (15.12%) zeros Zeros
  • 1
  • 2
  • 3

Variables

ets_half_hour_price

numerical

Approximate Distinct Count 300
Approximate Unique (%) 20.2%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 23.2 KB
Mean 23.9736
Minimum -19
Maximum 42
Zeros 10
Zeros (%) 0.7%
Negatives 39
Negatives (%) 2.6%
  • ets_half_hour_price is skewed left (γ1 = -1.3232)

Quantile Statistics

Minimum -19
5-th Percentile 5.135
Q1 20
Median 25.4
Q3 30
95-th Percentile 36
Maximum 42
Range 61
IQR 10

Descriptive Statistics

Mean 23.9736
Standard Deviation 9.4095
Variance 88.5391
Sum 35672.75
Skewness -1.3232
Kurtosis 2.8328
Coefficient of Variation 0.3925
  • ets_half_hour_price is not normally distributed (p-value 0.0008431454552788606)
  • ets_half_hour_price has 69 outliers

lolp_2hour

categorical

Approximate Distinct Count 1
Approximate Unique (%) 0.1%
Missing 0
Missing (%) 0.0%
Memory Size 98.8 KB

Length

Mean 3
Standard Deviation 0
Median 3
Minimum 3
Maximum 3

Sample

1st row 0.0
2nd row 0.0
3rd row 0.0
4th row 0.0
5th row 0.0

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 2976
  • lolp_2hour has words of constant length

transmission_system_demand_forecast

numerical

Approximate Distinct Count 1366
Approximate Unique (%) 91.8%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 23.2 KB
Mean 23645.8878
Minimum 17400
Maximum 33202
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • transmission_system_demand_forecast is skewed right (γ1 = 0.5463)

Quantile Statistics

Minimum 17400
5-th Percentile 19492.4
Q1 20946.25
Median 22940.5
Q3 26087.5
95-th Percentile 29486.35
Maximum 33202
Range 15802
IQR 5141.25

Descriptive Statistics

Mean 23645.8878
Standard Deviation 3287.5149
Variance 1.0808e+07
Sum 3.5185e+07
Skewness 0.5463
Kurtosis -0.6803
Coefficient of Variation 0.139

sin48_settlement_period

numerical

Approximate Distinct Count 45
Approximate Unique (%) 3.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 23.2 KB
Mean -1.1938e-17
Minimum -1
Maximum 1
Zeros 0
Zeros (%) 0.0%
Negatives 744
Negatives (%) 50.0%

Quantile Statistics

Minimum -1
5-th Percentile -0.9914
Q1 -0.7071
Median -6.1232e-17
Q3 0.7071
95-th Percentile 0.9914
Maximum 1
Range 2
IQR 1.4142

Descriptive Statistics

Mean -1.1938e-17
Standard Deviation 0.7073
Variance 0.5003
Sum -1.7764e-14
Skewness -5.0648e-17
Kurtosis -1.5
Coefficient of Variation -5.9252e+16
  • sin48_settlement_period is not normally distributed (p-value 0.00018534457304060034)

cos48_settlement_period

numerical

Approximate Distinct Count 43
Approximate Unique (%) 2.9%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 23.2 KB
Mean -4.9542e-17
Minimum -1
Maximum 1
Zeros 0
Zeros (%) 0.0%
Negatives 744
Negatives (%) 50.0%

Quantile Statistics

Minimum -1
5-th Percentile -0.9914
Q1 -0.7071
Median -6.1232e-17
Q3 0.7071
95-th Percentile 0.9914
Maximum 1
Range 2
IQR 1.4142

Descriptive Statistics

Mean -4.9542e-17
Standard Deviation 0.7073
Variance 0.5003
Sum -7.3719e-14
Skewness -1.4013e-16
Kurtosis -1.5
Coefficient of Variation -1.4278e+16
  • cos48_settlement_period is not normally distributed (p-value 0.00018534457304060034)

ema_half_hour

numerical

Approximate Distinct Count 1077
Approximate Unique (%) 89.9%
Missing 290
Missing (%) 19.5%
Infinite 0
Infinite (%) 0.0%
Memory Size 18.7 KB
Mean 23.6799
Minimum -43.1224
Maximum 70.446
Zeros 6
Zeros (%) 0.4%
Negatives 37
Negatives (%) 2.5%
  • ema_half_hour is skewed left (γ1 = -1.2824)

Quantile Statistics

Minimum -43.1224
5-th Percentile 3.0312
Q1 18.2405
Median 25
Q3 30.8459
95-th Percentile 38.8424
Maximum 70.446
Range 113.5684
IQR 12.6054

Descriptive Statistics

Mean 23.6799
Standard Deviation 11.512
Variance 132.5251
Sum 28368.528
Skewness -1.2824
Kurtosis 4.2195
Coefficient of Variation 0.4861
  • ema_half_hour is not normally distributed (p-value 0.00031875709094903137)
  • ema_half_hour has 34 outliers

MACD

numerical

Approximate Distinct Count 974
Approximate Unique (%) 81.3%
Missing 290
Missing (%) 19.5%
Infinite 0
Infinite (%) 0.0%
Memory Size 18.7 KB
Mean 0.03675
Minimum -5.7843
Maximum 5.5773
Zeros 172
Zeros (%) 11.6%
Negatives 507
Negatives (%) 34.1%
  • MACD is skewed right (γ1 = 0.3209)

Quantile Statistics

Minimum -5.7843
5-th Percentile -0.7386
Q1 -0.1127
Median 0
Q3 0.1478
95-th Percentile 1.0094
Maximum 5.5773
Range 11.3616
IQR 0.2605

Descriptive Statistics

Mean 0.03675
Standard Deviation 0.6723
Variance 0.452
Sum 44.0208
Skewness 0.3209
Kurtosis 17.5707
Coefficient of Variation 18.2965
  • MACD is not normally distributed (p-value 2.744347208367281e-22)
  • MACD has 227 outliers

atr

numerical

Approximate Distinct Count 448
Approximate Unique (%) 37.4%
Missing 290
Missing (%) 19.5%
Infinite 0
Infinite (%) 0.0%
Memory Size 18.7 KB
Mean 5.5717
Minimum 0
Maximum 80.05
Zeros 225
Zeros (%) 15.1%
Negatives 0
Negatives (%) 0.0%
  • atr is skewed right (γ1 = 2.9325)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0.535
Median 4
Q3 8
95-th Percentile 17.415
Maximum 80.05
Range 80.05
IQR 7.465

Descriptive Statistics

Mean 5.5717
Standard Deviation 6.5243
Variance 42.5664
Sum 6674.95
Skewness 2.9325
Kurtosis 18.6063
Coefficient of Variation 1.171
  • atr is not normally distributed (p-value 1.1667861529110783e-16)
  • atr has 48 outliers

weighted_top_buy

numerical

Approximate Distinct Count 1341
Approximate Unique (%) 90.1%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 23.2 KB
Mean 17.1714
Minimum -62.25
Maximum 47.2454
Zeros 3
Zeros (%) 0.2%
Negatives 103
Negatives (%) 6.9%
  • weighted_top_buy is skewed left (γ1 = -1.7908)

Quantile Statistics

Minimum -62.25
5-th Percentile -7.2697
Q1 11.5525
Median 19.864
Q3 25.8109
95-th Percentile 34.378
Maximum 47.2454
Range 109.4954
IQR 14.2584

Descriptive Statistics

Mean 17.1714
Standard Deviation 13.8753
Variance 192.5233
Sum 25550.9909
Skewness -1.7908
Kurtosis 5.3866
Coefficient of Variation 0.808
  • weighted_top_buy is not normally distributed (p-value 0.0006609883773125087)
  • weighted_top_buy has 69 outliers

weighted_top_sell

numerical

Approximate Distinct Count 1207
Approximate Unique (%) 81.1%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 23.2 KB
Mean 29.533
Minimum -32.5319
Maximum 93.9989
Zeros 2
Zeros (%) 0.1%
Negatives 28
Negatives (%) 1.9%
  • weighted_top_sell is skewed left (γ1 = -0.6566)

Quantile Statistics

Minimum -32.5319
5-th Percentile 11.9943
Q1 24.8937
Median 30
Q3 35.4528
95-th Percentile 43.2292
Maximum 93.9989
Range 126.5308
IQR 10.5591

Descriptive Statistics

Mean 29.533
Standard Deviation 10.521
Variance 110.6919
Sum 43945.1174
Skewness -0.6566
Kurtosis 5.8175
Coefficient of Variation 0.3562
  • weighted_top_sell is not normally distributed (p-value 1.8561548468626408e-07)
  • weighted_top_sell has 66 outliers

-1 pressure

numerical

Approximate Distinct Count 725
Approximate Unique (%) 48.7%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 23.2 KB
Mean 56.3913
Minimum 0.1
Maximum 570.1
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • -1 pressure is skewed right (γ1 = 3.4044)

Quantile Statistics

Minimum 0.1
5-th Percentile 3.57
Q1 25
Median 50
Q3 77.95
95-th Percentile 128.245
Maximum 570.1
Range 570
IQR 52.95

Descriptive Statistics

Mean 56.3913
Standard Deviation 46.4329
Variance 2156.0185
Sum 83910.3
Skewness 3.4044
Kurtosis 27.9624
Coefficient of Variation 0.8234
  • -1 pressure is not normally distributed (p-value 2.893665239998731e-06)
  • -1 pressure has 32 outliers

-10 pressure

numerical

Approximate Distinct Count 1043
Approximate Unique (%) 70.1%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 23.2 KB
Mean 129.8292
Minimum 0.1
Maximum 716.9
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • -10 pressure is skewed right (γ1 = 2.3534)

Quantile Statistics

Minimum 0.1
5-th Percentile 30.035
Q1 76.775
Median 118.9
Q3 166.425
95-th Percentile 251.685
Maximum 716.9
Range 716.8
IQR 89.65

Descriptive Statistics

Mean 129.8292
Standard Deviation 81.9955
Variance 6723.268
Sum 193185.8
Skewness 2.3534
Kurtosis 11.2711
Coefficient of Variation 0.6316
  • -10 pressure is not normally distributed (p-value 0.002321087791849614)
  • -10 pressure has 38 outliers

-100 pressure

numerical

Approximate Distinct Count 1321
Approximate Unique (%) 88.8%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 23.2 KB
Mean 484.5547
Minimum 50.6
Maximum 1160.1
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • -100 pressure is skewed right (γ1 = 0.6335)

Quantile Statistics

Minimum 50.6
5-th Percentile 170.755
Q1 360.15
Median 471.35
Q3 587.025
95-th Percentile 908.15
Maximum 1160.1
Range 1109.5
IQR 226.875

Descriptive Statistics

Mean 484.5547
Standard Deviation 205.119
Variance 42073.8072
Sum 721017.4
Skewness 0.6335
Kurtosis 0.528
Coefficient of Variation 0.4233
  • -100 pressure has 67 outliers

-1000 pressure

numerical

Approximate Distinct Count 1283
Approximate Unique (%) 86.2%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 23.2 KB
Mean 690.0993
Minimum 122.6
Maximum 1610.1
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • -1000 pressure is skewed right (γ1 = 0.9645)

Quantile Statistics

Minimum 122.6
5-th Percentile 300.94
Q1 585.55
Median 660.9
Q3 761.325
95-th Percentile 1217.73
Maximum 1610.1
Range 1487.5
IQR 175.775

Descriptive Statistics

Mean 690.0993
Standard Deviation 233.7251
Variance 54627.4042
Sum 1.0269e+06
Skewness 0.9645
Kurtosis 2.1998
Coefficient of Variation 0.3387
  • -1000 pressure is not normally distributed (p-value 1.2360483437420354e-06)
  • -1000 pressure has 227 outliers

1 pressure

numerical

Approximate Distinct Count 549
Approximate Unique (%) 36.9%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 23.2 KB
Mean 50.171
Minimum 0.2
Maximum 725
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • 1 pressure is skewed right (γ1 = 4.4414)

Quantile Statistics

Minimum 0.2
5-th Percentile 5
Q1 25
Median 46
Q3 70
95-th Percentile 114.685
Maximum 725
Range 724.8
IQR 45

Descriptive Statistics

Mean 50.171
Standard Deviation 38.5478
Variance 1485.9356
Sum 74654.4
Skewness 4.4414
Kurtosis 63.7386
Coefficient of Variation 0.7683
  • 1 pressure is not normally distributed (p-value 7.007129978508299e-11)
  • 1 pressure has 29 outliers

10 pressure

numerical

Approximate Distinct Count 835
Approximate Unique (%) 56.1%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 23.2 KB
Mean 120.9399
Minimum 1
Maximum 797
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • 10 pressure is skewed right (γ1 = 2.2139)

Quantile Statistics

Minimum 1
5-th Percentile 32.405
Q1 75
Median 114.6
Q3 153.225
95-th Percentile 234.76
Maximum 797
Range 796
IQR 78.225

Descriptive Statistics

Mean 120.9399
Standard Deviation 68.0578
Variance 4631.8585
Sum 179958.5
Skewness 2.2139
Kurtosis 15.2696
Coefficient of Variation 0.5627
  • 10 pressure is not normally distributed (p-value 4.3823349007329856e-05)
  • 10 pressure has 35 outliers

100 pressure

numerical

Approximate Distinct Count 1230
Approximate Unique (%) 82.7%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 23.2 KB
Mean 363.222
Minimum 54.3
Maximum 1149.5
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • 100 pressure is skewed right (γ1 = 1.084)

Quantile Statistics

Minimum 54.3
5-th Percentile 180.135
Q1 270.5
Median 342
Q3 433.8
95-th Percentile 603.395
Maximum 1149.5
Range 1095.2
IQR 163.3

Descriptive Statistics

Mean 363.222
Standard Deviation 136.7197
Variance 18692.277
Sum 540474.3
Skewness 1.084
Kurtosis 2.5095
Coefficient of Variation 0.3764
  • 100 pressure is not normally distributed (p-value 0.00661521875240697)
  • 100 pressure has 34 outliers

1000 pressure

numerical

Approximate Distinct Count 1271
Approximate Unique (%) 85.4%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 23.2 KB
Mean 696.3296
Minimum 134.1
Maximum 1568.7
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • 1000 pressure is skewed right (γ1 = 0.8308)

Quantile Statistics

Minimum 134.1
5-th Percentile 275.105
Q1 595
Median 666.3
Q3 765.475
95-th Percentile 1177.935
Maximum 1568.7
Range 1434.6
IQR 170.475

Descriptive Statistics

Mean 696.3296
Standard Deviation 228.8729
Variance 52382.8187
Sum 1.0361e+06
Skewness 0.8308
Kurtosis 2.3478
Coefficient of Variation 0.3287
  • 1000 pressure is not normally distributed (p-value 2.9313385853778825e-06)
  • 1000 pressure has 227 outliers

MACD_2

numerical

Approximate Distinct Count 1478
Approximate Unique (%) 99.3%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 23.2 KB
Mean -15.6289
Minimum -2067
Maximum 155
Zeros 11
Zeros (%) 0.7%
Negatives 795
Negatives (%) 53.4%
  • MACD_2 is skewed left (γ1 = -15.7046)

Quantile Statistics

Minimum -2067
5-th Percentile -81.6893
Q1 -16.841
Median -0.9897
Q3 7.7093
95-th Percentile 18.5461
Maximum 155
Range 2222
IQR 24.5503

Descriptive Statistics

Mean -15.6289
Standard Deviation 80.4671
Variance 6474.9501
Sum -23255.8769
Skewness -15.7046
Kurtosis 340.936
Coefficient of Variation -5.1486
  • MACD_2 is not normally distributed (p-value 2.793758450774286e-24)
  • MACD_2 has 130 outliers

Interactions

Correlations

Missing Values

sb.